Interview Questions

1. Which of the following is not a class of constraint in SQL Server ?

Options:

a. NOT NULL

b. CHECK

c. NULL

d. UNIQUE

Reveal Answer

2. Constraints can be applied on :

Options:

a. Column

b. Table

c. Field

d. All of the mentioned

Reveal Answer

3. How many types of constraints are present in SQL Server ?

Options:

a. 4

b. 5

c. 6

d. 7

Reveal Answer

4. What is true about Unique and primary key?

Options:

a. Unique can have multiple NULL values but Primary can’t have.

b. Unique can have single NULL value but Primary can’t have even single.

c. Both can have duplicate values

d. None of the Mentioned

Reveal Answer

5. Which key accepts multiple NULL values?

Options:

a. Foreign Key

b. Unique Key

c. Primary Key

d. None of the Mentioned

Reveal Answer

6. Point out the correct statement :

Options:

a. CHECK constraints enforce domain integrity

b. UNIQUE constraints enforce the uniqueness of the values in a set of columns

c. In a UNIQUE constraint, no two rows in the table can have the same value for the columns

d. All of the mentioned

Reveal Answer

7. How to add a Constraint:

Options:

a. ALTER TABLE<Table Name> ADD CONSTRAINT<Constraint name> Constraint (column name)

b. ADD TABLE<Table Name> ADD CONSTRAINT<Constraint name> Constaint (column name)

c. ALTER TABLE<Table Name> ADD CONSTRAINT<Constraint name>

d. All the above

Reveal Answer

8. Which key columns of the child table is always linked to either primary key or unique column of the parent table It can be used only when 1. The referenced table has a unique or primary key constraint defined on the appropriate column 2. Data types of the referencing table columns exactly match the data types of the referenced table

Options:

a. Primary Key

b. Default

c. Check

d. Foreign Key

Reveal Answer

9. Which of the following code applies not null constraint on the fname column of the employees table

Options:

a. Create table employees (eid int, Fname varchar 20 notnull)

b. Create table employees (eid int, Fname varchar 20 not null)

c. Create table employees (eid int, Fname varchar 20 foreign key)

d. All the above

Reveal Answer

10. Is it possible to insert null values in the foreign key constraint column

Options:

a. yes

b. No

Reveal Answer

11. what is a composite primary key

Options:

a. A primary key applied on more than one column

b. When a table contains more than one primary key

c. All the above

d. Non of these

Reveal Answer

12. What is a unique constraint

Options:

a. Unique constraint will not allow duplicate values into the columns on which it is defined

b. Unique constraints makes table rows unique

c. Unique constraint will not allow redundant rows

d. All the above

Reveal Answer

13. Which of the following code is correct for check constraint

Options:

a. Create table Employees (eid int, Ename varchar(10) Age int exp int check(exp<10) )

b. Create table Employees (eid int, Ename varchar(10) Age int constraint chk_age_ int check(age>exp) )

c. Create table Employees ( eid int, Ename varchar(10) Age int Constraint check(age>exp) )

d. All the above

Reveal Answer

14. How many primary keys can exist in a table

Options:

a. 1

b. 3

c. 4

d. 2

Reveal Answer

15. What is the use of constraints in sql server

Options:

a. constraints are used for restricting data coming into tables

b. constraints are used for enforcing business rules

c. constraints used for validating data

d. All the above

Reveal Answer

Interview Questions and Answer

1. Which of the following is not a class of constraint in SQL Server ?

2. Constraints can be applied on :

3. How many types of constraints are present in SQL Server ?

4. What is true about Unique and primary key?

5. Which key accepts multiple NULL values?

6. Point out the correct statement :

7. How to add a Constraint:

9. Which of the following code applies not null constraint on the fname column of the employees table

10. Is it possible to insert null values in the foreign key constraint column

11. what is a composite primary key

12. What is a unique constraint

13. Which of the following code is correct for check constraint

14. How many primary keys can exist in a table

15. What is the use of constraints in sql server

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources